Materialized View Generation Using Apriori Algorithm

Materialized View Generation Using Apriori Algorithm

Data analysis is an important issue in business world in many respects. Different business organizations have data scientists, knowledge workers to analyze the business patterns and the customer behavior. Scrutinizing the past data to predict the future result has many aspects and understanding the nature of the query is one of them. Business analysts try to do this from a big data set which ma...

Optimized Generation and Maintenance of Materialized View using Adaptive Mechanism

Data Warehouse is storage of enormous amount of data gathered from multiple data sources, which is mainly used by managers for analysis purpose. Hence to make this data available in less amount of time is essential. Using Materialize view we can have result of query in less amount of time compared to access the same from base tables. To materialize all of the views is not possible since it requ...

An Improved Algorithm for Materialized View Selection

The data warehouse is subject oriented, integrated, nonvolatile and time-varying data sets, which is used to support management decision-making. A data warehouse stores materialized views of data from one or more sources, with the purpose of efficiently implementing Decision-support or OLAP queries. One of the most important decisions in designing a data warehouse is the selection of materializ...

Materialized View Maintenance Using Version Numbers

A data warehouse stores materialized views over data from one or more sources in order to provide fast access to the integrated data, regardless of the availability of the data sources. In this paper, we define a new compensation algorithm that is used in removing the anomalies, caused by interfering updates at the base relations, of incremental computation for updating the view. Unlike existin...

Genetic Algorithm for Materialized View Selection in Data Warehouse Environments